Model Table MARKETING CAMPAIGN DIM

This model dimension represents marketing campaigns and is based on the IFS Cloud fact FACT_BUSINESS_ACTIVITY. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute	Description (where applicable)
Marketing Campaign	The ID of the marketing campaign.
Marketing Campaign Code	The ID of the marketing campaign.
Marketing Campaign Code Type	The ID and the type of the marketing campaign.
Marketing Campaign Description	The description of the marketing campaign.
Marketing Campaign Status	The status of the marketing campaign.
Marketing Campaign Type	The type assigned to the marketing campaign and defines the nature of the campaign.

USED BY MODEL(S)

Model Name

Crm

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
MARKETING CAMPAIGN DIM	DIM_MARKETING_CAMPAIGN_TM	DIM_MARKETING_CAMPAIGN_BI	DIM_MARKETING_CAMPAIGN	On Line